package athabasca.ca.util;

import java.sql.*;

public class postgreSQL {
	
	public static String dbURL = "jdbc:postgresql://localhost:5433/";
	public static String dbName = "UsageObserver_Storage";
	public static String dbUser = "postgres";
	public static String dbPwd = "@th4b4sc4";
	public final static Connection postgreSQLConn () throws Exception {
		Class.forName("org.postgresql.Driver").newInstance();
        // Construct the database address
        String dbaseURL = dbURL + dbName; //Storage
        // Make the database connection
        Connection dbConnection = 
            DriverManager.getConnection(dbaseURL, dbUser, dbPwd); //Color
        
        return dbConnection;
	}
}
